Other functions

SLEEP

SLEEP(sec)

This function pauses for the specified time then resumes the operations.

Parameters:sec -- sleep time. The unit is second and inputs double type value.
Return type:INT
SELECT SLEEP(3);

It pauses for 3 seconds.

SYS_GUID

SYS_GUID()

It returns the unique hexadecimal string of 32 characters randomly.

SELECT SYS_GUID();
sys_guid()
==================================
'938210043A7B4455927A8697FB2571FF'